Release 10.1A: OpenEdge Data Management:
DataServer for ODBC

Cursors

A cursor is like a pointer that points to consecutive records in a table. Progress uses cursors to keep track of where it is in a table; for example, when it processes FOR EACH statements. Suppose that you are reading records from the customer table using the cust-num index, and your current record is customer number 50. This means that Progress has a cursor positioned at cust-num 50. Note that Progress maintains cursor positioning across equivalent FIND statements.

The DataServer allows applications that access ODBC data sources to imitate Progress cursor behavior for FIND cursors. FOR EACH and OPEN QUERY statements do not retain cursor position across other queries or against a FIND statement.